select a.dftpic as dftpic1, b.Latitude as b_Latitude, b.Longitude as b_Longitude,* from [houses] a, [base_property] b, [base_cityDistrict] c where audit=1 and a.pid = b.pid and b.did = c.id and a.del=0 and a.locker=0 and b.del=0 and b.locker=0 and a.isShowEn=0 and (a.houseprice >= 20000 and a.houseprice <= 30000) and (a.houseArea >= 100 and a.houseArea <= 200) and (b.cnpropertyname like '%Old house in Wukang Road%' or b.enpropertyname like '%Old house in Wukang Road%') order by updateTime Desc, a.dftpic desc
Delicated decoration,the property comprises a brigh and sunny livingroom and well equipped contemporary kitchen, north-south transparent, good ventilation, good...
located in the heart of FFC Area, this recently renovated three bedroom paradise exquisite decoration, nostalgic furnishings, all of which let you enjoy the bus...
It is a protected historical property. It is also the Former Residence of one of the most famous Chinese writer. A strong sense of history brings this street a ...
Delicated decoration,the property comprises a brigh and sunny livingroom and well equipped contemporary kitchen, north-south transparent, good ventilation, good...